Telecom Data Report

Dataset statistics

Number of variables	38
Number of observations	7043
Missing cells	26972
Missing cells (%)	10.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.0 MiB
Average record size in memory	304.0 B

Variable types

Categorical	10
Numeric	15
Boolean	13

Alerts

`Customer ID` has a high cardinality: 7043 distinct values	High cardinality
`City` has a high cardinality: 1106 distinct values	High cardinality
`Zip Code` is highly correlated with `Latitude` and 1 other fields	High correlation
`Latitude` is highly correlated with `Zip Code` and 2 other fields	High correlation
`Longitude` is highly correlated with `Zip Code` and 1 other fields	High correlation
`Tenure in Months` is highly correlated with `Offer` and 7 other fields	High correlation
`Avg Monthly Long Distance Charges` is highly correlated with `Total Long Distance Charges`	High correlation
`Monthly Charge` is highly correlated with `Phone Service` and 7 other fields	High correlation
`Total Charges` is highly correlated with `Tenure in Months` and 10 other fields	High correlation
`Total Long Distance Charges` is highly correlated with `Tenure in Months` and 3 other fields	High correlation
`Total Revenue` is highly correlated with `Tenure in Months` and 10 other fields	High correlation
`Age` is highly correlated with `Avg Monthly GB Download`	High correlation
`Avg Monthly GB Download` is highly correlated with `Age`	High correlation
`Streaming Movies` is highly correlated with `Streaming TV` and 4 other fields	High correlation
`Customer Status` is highly correlated with `Tenure in Months` and 2 other fields	High correlation
`Internet Service` is highly correlated with `Monthly Charge` and 1 other fields	High correlation
`Churn Category` is highly correlated with `Churn Reason`	High correlation
`Online Security` is highly correlated with `Internet Service`	High correlation
`Internet Type` is highly correlated with `Monthly Charge`	High correlation
`Online Backup` is highly correlated with `Tenure in Months` and 2 other fields	High correlation
`Unlimited Data` is highly correlated with `Total Extra Data Charges`	High correlation
`Streaming Music` is highly correlated with `Streaming TV` and 1 other fields	High correlation
`Premium Tech Support` is highly correlated with `Internet Service`	High correlation
`Multiple Lines` is highly correlated with `Monthly Charge` and 2 other fields	High correlation
`Phone Service` is highly correlated with `Monthly Charge`	High correlation
`Churn Reason` is highly correlated with `Latitude` and 1 other fields	High correlation
`Streaming TV` is highly correlated with `Streaming Movies` and 4 other fields	High correlation
`Device Protection Plan` is highly correlated with `Tenure in Months` and 2 other fields	High correlation
`Married` is highly correlated with `Number of Referrals`	High correlation
`Number of Referrals` is highly correlated with `Married`	High correlation
`Offer` is highly correlated with `Tenure in Months` and 4 other fields	High correlation
`Contract` is highly correlated with `Tenure in Months` and 3 other fields	High correlation
`Total Extra Data Charges` is highly correlated with `Unlimited Data`	High correlation
`Avg Monthly Long Distance Charges` has 682 (9.7%) missing values	Missing
`Multiple Lines` has 682 (9.7%) missing values	Missing
`Internet Type` has 1526 (21.7%) missing values	Missing
`Avg Monthly GB Download` has 1526 (21.7%) missing values	Missing
`Online Security` has 1526 (21.7%) missing values	Missing
`Online Backup` has 1526 (21.7%) missing values	Missing
`Device Protection Plan` has 1526 (21.7%) missing values	Missing
`Premium Tech Support` has 1526 (21.7%) missing values	Missing
`Streaming TV` has 1526 (21.7%) missing values	Missing
`Streaming Movies` has 1526 (21.7%) missing values	Missing
`Streaming Music` has 1526 (21.7%) missing values	Missing
`Unlimited Data` has 1526 (21.7%) missing values	Missing
`Churn Category` has 5174 (73.5%) missing values	Missing
`Churn Reason` has 5174 (73.5%) missing values	Missing
`Customer ID` is uniformly distributed	Uniform
`Customer ID` has unique values	Unique
`Number of Dependents` has 5416 (76.9%) zeros	Zeros
`Number of Referrals` has 3821 (54.3%) zeros	Zeros
`Total Refunds` has 6518 (92.5%) zeros	Zeros
`Total Extra Data Charges` has 6315 (89.7%) zeros	Zeros
`Total Long Distance Charges` has 682 (9.7%) zeros	Zeros

Reproduction

Analysis started	2022-11-27 14:08:05.228891
Analysis finished	2022-11-27 14:08:21.253795
Duration	16.02 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Customer ID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	7043
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

0002-ORFBO	1
6616-AALSR	1
6625-UTXEW	1
6625-IUTTT	1
6625-FLENO	1
Other values (7038)	7038

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	70430
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	7043 ?
Unique (%)	100.0%

Sample

1st row	0002-ORFBO
2nd row	0003-MKNFE
3rd row	0004-TLHLJ
4th row	0011-IGKFF
5th row	0013-EXCHZ

Common Values

Value	Count	Frequency (%)
0002-ORFBO	1	< 0.1%
6616-AALSR	1	< 0.1%
6625-UTXEW	1	< 0.1%
6625-IUTTT	1	< 0.1%
6625-FLENO	1	< 0.1%
6624-JDRDS	1	< 0.1%
6621-YOBKI	1	< 0.1%
6621-NRZAK	1	< 0.1%
6620-JDYNW	1	< 0.1%
6620-HVDUJ	1	< 0.1%
Other values (7033)	7033	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
0002-orfbo	1	< 0.1%
0019-efaep	1	< 0.1%
0011-igkff	1	< 0.1%
0013-exchz	1	< 0.1%
0013-mhzwf	1	< 0.1%
0013-smeoe	1	< 0.1%
0014-bmaqu	1	< 0.1%
0015-uocoj	1	< 0.1%
0016-qljis	1	< 0.1%
0017-dinoc	1	< 0.1%
Other values (7033)	7033	99.9%

Most occurring characters

Value	Count	Frequency (%)
-	7043	10.0%
2	2901	4.1%
9	2881	4.1%
6	2870	4.1%
7	2836	4.0%
0	2831	4.0%
8	2812	4.0%
5	2810	4.0%
3	2791	4.0%
1	2726	3.9%
Other values (27)	37929	53.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35215	50.0%
Decimal Number	28172	40.0%
Dash Punctuation	7043	10.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	1442	4.1%
H	1396	4.0%
B	1393	4.0%
S	1386	3.9%
V	1382	3.9%
T	1374	3.9%
Z	1368	3.9%
C	1368	3.9%
F	1363	3.9%
L	1363	3.9%
Other values (16)	21380	60.7%

Decimal Number

Value	Count	Frequency (%)
2	2901	10.3%
9	2881	10.2%
6	2870	10.2%
7	2836	10.1%
0	2831	10.0%
8	2812	10.0%
5	2810	10.0%
3	2791	9.9%
1	2726	9.7%
4	2714	9.6%

Dash Punctuation

Value	Count	Frequency (%)
-	7043	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	35215	50.0%
Latin	35215	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	1442	4.1%
H	1396	4.0%
B	1393	4.0%
S	1386	3.9%
V	1382	3.9%
T	1374	3.9%
Z	1368	3.9%
C	1368	3.9%
F	1363	3.9%
L	1363	3.9%
Other values (16)	21380	60.7%

Common

Value	Count	Frequency (%)
-	7043	20.0%
2	2901	8.2%
9	2881	8.2%
6	2870	8.1%
7	2836	8.1%
0	2831	8.0%
8	2812	8.0%
5	2810	8.0%
3	2791	7.9%
1	2726	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	70430	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	7043	10.0%
2	2901	4.1%
9	2881	4.1%
6	2870	4.1%
7	2836	4.0%
0	2831	4.0%
8	2812	4.0%
5	2810	4.0%
3	2791	4.0%
1	2726	3.9%
Other values (27)	37929	53.9%

Gender
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

Male	3555
Female	3488

Length

Max length	6
Median length	4
Mean length	4.990487008
Min length	4

Characters and Unicode

Total characters	35148
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Female
2nd row	Male
3rd row	Male
4th row	Male
5th row	Female

Common Values

Value	Count	Frequency (%)
Male	3555	50.5%
Female	3488	49.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
male	3555	50.5%
female	3488	49.5%

Most occurring characters

Value	Count	Frequency (%)
e	10531	30.0%
a	7043	20.0%
l	7043	20.0%
M	3555	10.1%
F	3488	9.9%
m	3488	9.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28105	80.0%
Uppercase Letter	7043	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	10531	37.5%
a	7043	25.1%
l	7043	25.1%
m	3488	12.4%

Uppercase Letter

Value	Count	Frequency (%)
M	3555	50.5%
F	3488	49.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35148	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	10531	30.0%
a	7043	20.0%
l	7043	20.0%
M	3555	10.1%
F	3488	9.9%
m	3488	9.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	35148	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	10531	30.0%
a	7043	20.0%
l	7043	20.0%
M	3555	10.1%
F	3488	9.9%
m	3488	9.9%

Age
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	62
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	46.50972597

Minimum	19
Maximum	80
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	19
5-th percentile	21
Q1	32
median	46
Q3	60
95-th percentile	75
Maximum	80
Range	61
Interquartile range (IQR)	28

Descriptive statistics

Standard deviation	16.75035166
Coefficient of variation (CV)	0.3601472876
Kurtosis	-1.00284948
Mean	46.50972597
Median Absolute Deviation (MAD)	14
Skewness	0.1621864487
Sum	327568
Variance	280.5742806
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42	156	2.2%
47	153	2.2%
40	150	2.1%
44	148	2.1%
23	146	2.1%
56	144	2.0%
62	143	2.0%
35	142	2.0%
21	140	2.0%
33	139	2.0%
Other values (52)	5582	79.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	127	1.8%
20	127	1.8%
21	140	2.0%
22	130	1.8%
23	146	2.1%
24	109	1.5%
25	138	2.0%
26	115	1.6%
27	132	1.9%
28	119	1.7%

Value	Count	Frequency (%)
80	66	0.9%
79	76	1.1%
78	63	0.9%
77	72	1.0%
76	69	1.0%
75	74	1.1%
74	76	1.1%
73	85	1.2%
72	58	0.8%
71	68	1.0%

Married
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 KiB

False	3641
True	3402

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3641	51.7%
True	3402	48.3%

Number of Dependents
Real number (ℝ_≥0)

ZEROS

Distinct	10
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.4686923186

Minimum	0
Maximum	9
Zeros	5416
Zeros (%)	76.9%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3
Maximum	9
Range	9
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.9628019509
Coefficient of variation (CV)	2.054230276
Kurtosis	4.446357934
Mean	0.4686923186
Median Absolute Deviation (MAD)	0
Skewness	2.109931981
Sum	3301
Variance	0.9269875967
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5416	76.9%
1	553	7.9%
2	531	7.5%
3	517	7.3%
5	10	0.1%
4	9	0.1%
6	3	< 0.1%
7	2	< 0.1%
9	1	< 0.1%
8	1	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5416	76.9%
1	553	7.9%
2	531	7.5%
3	517	7.3%
4	9	0.1%
5	10	0.1%
6	3	< 0.1%
7	2	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
9	1	< 0.1%
8	1	< 0.1%
7	2	< 0.1%
6	3	< 0.1%
5	10	0.1%
4	9	0.1%
3	517	7.3%
2	531	7.5%
1	553	7.9%
0	5416	76.9%

City
Categorical

HIGH CARDINALITY

Distinct	1106
Distinct (%)	15.7%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

Los Angeles	293
San Diego	285
San Jose	112
Sacramento	108
San Francisco	104
Other values (1101)	6141

Length

Max length	22
Median length	19
Mean length	9.203464433
Min length	3

Characters and Unicode

Total characters	64820
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Frazier Park
2nd row	Glendale
3rd row	Costa Mesa
4th row	Martinez
5th row	Camarillo

Common Values

Value	Count	Frequency (%)
Los Angeles	293	4.2%
San Diego	285	4.0%
San Jose	112	1.6%
Sacramento	108	1.5%
San Francisco	104	1.5%
Fresno	61	0.9%
Long Beach	60	0.9%
Oakland	52	0.7%
Escondido	51	0.7%
Stockton	44	0.6%
Other values (1096)	5873	83.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	718	6.9%
los	337	3.3%
angeles	293	2.8%
diego	285	2.8%
santa	181	1.8%
valley	171	1.7%
beach	169	1.6%
city	150	1.5%
sacramento	116	1.1%
jose	112	1.1%
Other values (1110)	7807	75.5%

Most occurring characters

Value	Count	Frequency (%)
a	6946	10.7%
e	6111	9.4%
n	5134	7.9%
o	5074	7.8%
l	3970	6.1%
r	3568	5.5%
i	3423	5.3%
	3296	5.1%
s	2853	4.4%
t	2602	4.0%
Other values (42)	21843	33.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51185	79.0%
Uppercase Letter	10339	16.0%
Space Separator	3296	5.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6946	13.6%
e	6111	11.9%
n	5134	10.0%
o	5074	9.9%
l	3970	7.8%
r	3568	7.0%
i	3423	6.7%
s	2853	5.6%
t	2602	5.1%
d	1669	3.3%
Other values (16)	9835	19.2%

Uppercase Letter

Value	Count	Frequency (%)
S	1576	15.2%
C	977	9.4%
L	869	8.4%
B	731	7.1%
A	651	6.3%
M	599	5.8%
P	582	5.6%
D	533	5.2%
F	471	4.6%
R	447	4.3%
Other values (15)	2903	28.1%

Space Separator

Value	Count	Frequency (%)
	3296	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	61524	94.9%
Common	3296	5.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6946	11.3%
e	6111	9.9%
n	5134	8.3%
o	5074	8.2%
l	3970	6.5%
r	3568	5.8%
i	3423	5.6%
s	2853	4.6%
t	2602	4.2%
d	1669	2.7%
Other values (41)	20174	32.8%

Common

Value	Count	Frequency (%)
	3296	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	64820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6946	10.7%
e	6111	9.4%
n	5134	7.9%
o	5074	7.8%
l	3970	6.1%
r	3568	5.5%
i	3423	5.3%
	3296	5.1%
s	2853	4.4%
t	2602	4.0%
Other values (42)	21843	33.7%

Zip Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1626
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	93486.07057

Minimum	90001
Maximum	96150
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	90001
5-th percentile	90241.1
Q1	92101
median	93518
Q3	95329
95-th percentile	96020.9
Maximum	96150
Range	6149
Interquartile range (IQR)	3228

Descriptive statistics

Standard deviation	1856.767505
Coefficient of variation (CV)	0.01986143491
Kurtosis	-1.173915431
Mean	93486.07057
Median Absolute Deviation (MAD)	1605
Skewness	-0.2096151191
Sum	658422395
Variance	3447585.568
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
92028	43	0.6%
92027	38	0.5%
92122	36	0.5%
92117	34	0.5%
92126	32	0.5%
92592	30	0.4%
92109	27	0.4%
92130	22	0.3%
92121	20	0.3%
92129	16	0.2%
Other values (1616)	6745	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
90001	4	0.1%
90002	4	0.1%
90003	5	0.1%
90004	5	0.1%
90005	4	0.1%
90006	5	0.1%
90007	5	0.1%
90008	5	0.1%
90010	4	0.1%
90011	5	0.1%

Value	Count	Frequency (%)
96150	2	< 0.1%
96148	4	0.1%
96146	4	0.1%
96145	3	< 0.1%
96143	4	0.1%
96142	3	< 0.1%
96141	3	< 0.1%
96140	4	0.1%
96137	4	0.1%
96136	4	0.1%

Latitude
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1626
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.19745482

Minimum	32.555828
Maximum	41.962127
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	32.555828
5-th percentile	32.886925
Q1	33.990646
median	36.205465
Q3	38.161321
95-th percentile	40.4974252
Maximum	41.962127
Range	9.406299
Interquartile range (IQR)	4.170675

Descriptive statistics

Standard deviation	2.468928682
Coefficient of variation (CV)	0.06820724534
Kurtosis	-1.160506077
Mean	36.19745482
Median Absolute Deviation (MAD)	2.169863
Skewness	0.3148042686
Sum	254938.6743
Variance	6.095608835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
33.362575	43	0.6%
33.141265	38	0.5%
32.85723	36	0.5%
32.825086	34	0.5%
32.886925	32	0.5%
33.507255	30	0.4%
32.787836	27	0.4%
32.957195	22	0.3%
32.898613	20	0.3%
32.961064	16	0.2%
Other values (1616)	6745	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
32.555828	5	0.1%
32.578103	4	0.1%
32.579134	4	0.1%
32.587557	5	0.1%
32.605012	4	0.1%
32.607964	5	0.1%
32.619465	5	0.1%
32.622999	4	0.1%
32.636792	4	0.1%
32.64164	5	0.1%

Value	Count	Frequency (%)
41.962127	4	0.1%
41.950683	4	0.1%
41.949216	4	0.1%
41.932207	3	< 0.1%
41.924174	3	< 0.1%
41.867908	4	0.1%
41.831901	4	0.1%
41.816595	4	0.1%
41.813521	4	0.1%
41.769709	4	0.1%

Longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	1625
Distinct (%)	23.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-119.7566837

Minimum	-124.301372
Maximum	-114.192901
Zeros	0
Zeros (%)	0.0%
Negative	7043
Negative (%)	100.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	-124.301372
5-th percentile	-122.9755
Q1	-121.78809
median	-119.595293
Q3	-117.969795
95-th percentile	-116.873258
Maximum	-114.192901
Range	10.108471
Interquartile range (IQR)	3.818295

Descriptive statistics

Standard deviation	2.154425092
Coefficient of variation (CV)	-0.01799001965
Kurtosis	-1.191290554
Mean	-119.7566837
Median Absolute Deviation (MAD)	1.848851
Skewness	-0.09193163502
Sum	-843446.3231
Variance	4.641547478
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-117.299644	43	0.6%
-116.967221	38	0.5%
-117.209774	36	0.5%
-117.199424	34	0.5%
-117.152162	32	0.5%
-117.029473	30	0.4%
-117.232376	27	0.4%
-117.202542	22	0.3%
-117.202937	20	0.3%
-117.134917	16	0.2%
Other values (1615)	6745	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-124.301372	4	0.1%
-124.240051	4	0.1%
-124.217378	4	0.1%
-124.210902	4	0.1%
-124.189977	4	0.1%
-124.163234	4	0.1%
-124.15428	4	0.1%
-124.121504	4	0.1%
-124.108897	4	0.1%
-124.098739	4	0.1%

Value	Count	Frequency (%)
-114.192901	4	0.1%
-114.36514	5	0.1%
-114.702256	4	0.1%
-114.71612	4	0.1%
-114.758334	5	0.1%
-114.850784	4	0.1%
-115.152865	2	< 0.1%
-115.191857	5	0.1%
-115.257009	5	0.1%
-115.287901	4	0.1%

Number of Referrals
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	12
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.951867102

Minimum	0
Maximum	11
Zeros	3821
Zeros (%)	54.3%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	9
Maximum	11
Range	11
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.0011993
Coefficient of variation (CV)	1.537604326
Kurtosis	0.7219639341
Mean	1.951867102
Median Absolute Deviation (MAD)	0
Skewness	1.446059625
Sum	13747
Variance	9.007197238
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
0	3821	54.3%
1	1086	15.4%
5	264	3.7%
3	255	3.6%
7	248	3.5%
9	238	3.4%
2	236	3.4%
4	236	3.4%
10	223	3.2%
6	221	3.1%
Other values (2)	215	3.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3821	54.3%
1	1086	15.4%
2	236	3.4%
3	255	3.6%
4	236	3.4%
5	264	3.7%
6	221	3.1%
7	248	3.5%
8	213	3.0%
9	238	3.4%

Value	Count	Frequency (%)
11	2	< 0.1%
10	223	3.2%
9	238	3.4%
8	213	3.0%
7	248	3.5%
6	221	3.1%
5	264	3.7%
4	236	3.4%
3	255	3.6%
2	236	3.4%

Tenure in Months
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	72
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.386767

Minimum	1
Maximum	72
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	9
median	29
Q3	55
95-th percentile	72
Maximum	72
Range	71
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	24.54206101
Coefficient of variation (CV)	0.757780516
Kurtosis	-1.387052361
Mean	32.386767
Median Absolute Deviation (MAD)	22
Skewness	0.2405426141
Sum	228100
Variance	602.3127587
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	613	8.7%
72	362	5.1%
2	238	3.4%
3	200	2.8%
4	176	2.5%
71	170	2.4%
5	133	1.9%
7	131	1.9%
10	127	1.8%
8	123	1.7%
Other values (62)	4770	67.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	613	8.7%
2	238	3.4%
3	200	2.8%
4	176	2.5%
5	133	1.9%
6	110	1.6%
7	131	1.9%
8	123	1.7%
9	119	1.7%
10	127	1.8%

Value	Count	Frequency (%)
72	362	5.1%
71	170	2.4%
70	119	1.7%
69	95	1.3%
68	100	1.4%
67	98	1.4%
66	89	1.3%
65	76	1.1%
64	80	1.1%
63	72	1.0%

Offer
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

None	3877
Offer B	824
Offer E	805
Offer D	602
Offer A	520

Length

Max length	7
Median length	4
Mean length	5.348573051
Min length	4

Characters and Unicode

Total characters	37670
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	None
2nd row	None
3rd row	Offer E
4th row	Offer D
5th row	None

Common Values

Value	Count	Frequency (%)
None	3877	55.0%
Offer B	824	11.7%
Offer E	805	11.4%
Offer D	602	8.5%
Offer A	520	7.4%
Offer C	415	5.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
none	3877	38.0%
offer	3166	31.0%
b	824	8.1%
e	805	7.9%
d	602	5.9%
a	520	5.1%
c	415	4.1%

Most occurring characters

Value	Count	Frequency (%)
e	7043	18.7%
f	6332	16.8%
N	3877	10.3%
o	3877	10.3%
n	3877	10.3%
O	3166	8.4%
r	3166	8.4%
	3166	8.4%
B	824	2.2%
E	805	2.1%
Other values (3)	1537	4.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	24295	64.5%
Uppercase Letter	10209	27.1%
Space Separator	3166	8.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	3877	38.0%
O	3166	31.0%
B	824	8.1%
E	805	7.9%
D	602	5.9%
A	520	5.1%
C	415	4.1%

Lowercase Letter

Value	Count	Frequency (%)
e	7043	29.0%
f	6332	26.1%
o	3877	16.0%
n	3877	16.0%
r	3166	13.0%

Space Separator

Value	Count	Frequency (%)
	3166	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	34504	91.6%
Common	3166	8.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	7043	20.4%
f	6332	18.4%
N	3877	11.2%
o	3877	11.2%
n	3877	11.2%
O	3166	9.2%
r	3166	9.2%
B	824	2.4%
E	805	2.3%
D	602	1.7%
Other values (2)	935	2.7%

Common

Value	Count	Frequency (%)
	3166	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37670	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	7043	18.7%
f	6332	16.8%
N	3877	10.3%
o	3877	10.3%
n	3877	10.3%
O	3166	8.4%
r	3166	8.4%
	3166	8.4%
B	824	2.2%
E	805	2.1%
Other values (3)	1537	4.1%

Phone Service
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 KiB

True	6361
False	682

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	6361	90.3%
False	682	9.7%

Avg Monthly Long Distance Charges
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	3583
Distinct (%)	56.3%
Missing	682
Missing (%)	9.7%
Infinite	0
Infinite (%)	0.0%
Mean	25.42051721

Minimum	1.01
Maximum	49.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	1.01
5-th percentile	3.27
Q1	13.05
median	25.69
Q3	37.68
95-th percentile	47.64
Maximum	49.99
Range	48.98
Interquartile range (IQR)	24.63

Descriptive statistics

Standard deviation	14.20037358
Coefficient of variation (CV)	0.5586185938
Kurtosis	-1.20599849
Mean	25.42051721
Median Absolute Deviation (MAD)	12.29
Skewness	-0.001970967867
Sum	161699.91
Variance	201.6506098
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.26	7	0.1%
30.07	6	0.1%
45.92	6	0.1%
30.09	6	0.1%
42.55	6	0.1%
49.51	6	0.1%
22.56	6	0.1%
22.83	6	0.1%
41.93	6	0.1%
18.42	6	0.1%
Other values (3573)	6300	89.5%
(Missing)	682	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.01	1	< 0.1%
1.02	3	< 0.1%
1.03	1	< 0.1%
1.05	1	< 0.1%
1.06	1	< 0.1%
1.07	1	< 0.1%
1.08	2	< 0.1%
1.09	2	< 0.1%
1.1	1	< 0.1%
1.12	3	< 0.1%

Value	Count	Frequency (%)
49.99	1	< 0.1%
49.98	3	< 0.1%
49.96	2	< 0.1%
49.95	2	< 0.1%
49.94	1	< 0.1%
49.92	1	< 0.1%
49.91	3	< 0.1%
49.9	3	< 0.1%
49.88	1	< 0.1%
49.87	1	< 0.1%

Multiple Lines
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	682
Missing (%)	9.7%
Memory size	13.9 KiB

False	3390
True	2971
(Missing)	682

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3390	48.1%
True	2971	42.2%
(Missing)	682	9.7%

Internet Service
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 KiB

True	5517
False	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	5517	78.3%
False	1526	21.7%

Internet Type
Categorical

HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.1%
Missing	1526
Missing (%)	21.7%
Memory size	55.1 KiB

Fiber Optic	3035
DSL	1652
Cable	830

Length

Max length	11
Median length	11
Mean length	7.701830705
Min length	3

Characters and Unicode

Total characters	42491
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Cable
2nd row	Cable
3rd row	Fiber Optic
4th row	Fiber Optic
5th row	Fiber Optic

Common Values

Value	Count	Frequency (%)
Fiber Optic	3035	43.1%
DSL	1652	23.5%
Cable	830	11.8%
(Missing)	1526	21.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
fiber	3035	35.5%
optic	3035	35.5%
dsl	1652	19.3%
cable	830	9.7%

Most occurring characters

Value	Count	Frequency (%)
i	6070	14.3%
b	3865	9.1%
e	3865	9.1%
F	3035	7.1%
r	3035	7.1%
	3035	7.1%
O	3035	7.1%
p	3035	7.1%
t	3035	7.1%
c	3035	7.1%
Other values (6)	7446	17.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	27600	65.0%
Uppercase Letter	11856	27.9%
Space Separator	3035	7.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	6070	22.0%
b	3865	14.0%
e	3865	14.0%
r	3035	11.0%
p	3035	11.0%
t	3035	11.0%
c	3035	11.0%
a	830	3.0%
l	830	3.0%

Uppercase Letter

Value	Count	Frequency (%)
F	3035	25.6%
O	3035	25.6%
D	1652	13.9%
S	1652	13.9%
L	1652	13.9%
C	830	7.0%

Space Separator

Value	Count	Frequency (%)
	3035	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	39456	92.9%
Common	3035	7.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	6070	15.4%
b	3865	9.8%
e	3865	9.8%
F	3035	7.7%
r	3035	7.7%
O	3035	7.7%
p	3035	7.7%
t	3035	7.7%
c	3035	7.7%
D	1652	4.2%
Other values (5)	5794	14.7%

Common

Value	Count	Frequency (%)
	3035	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42491	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	6070	14.3%
b	3865	9.1%
e	3865	9.1%
F	3035	7.1%
r	3035	7.1%
	3035	7.1%
O	3035	7.1%
p	3035	7.1%
t	3035	7.1%
c	3035	7.1%
Other values (6)	7446	17.5%

Avg Monthly GB Download
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	49
Distinct (%)	0.9%
Missing	1526
Missing (%)	21.7%
Infinite	0
Infinite (%)	0.0%
Mean	26.18995831

Minimum	2
Maximum	85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	13
median	21
Q3	30
95-th percentile	71
Maximum	85
Range	83
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	19.58658527
Coefficient of variation (CV)	0.7478662257
Kurtosis	0.6368415438
Mean	26.18995831
Median Absolute Deviation (MAD)	9
Skewness	1.184055978
Sum	144490
Variance	383.6343226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
19	220	3.1%
27	199	2.8%
30	193	2.7%
59	192	2.7%
26	191	2.7%
23	179	2.5%
22	172	2.4%
21	171	2.4%
18	164	2.3%
13	164	2.3%
Other values (39)	3672	52.1%
(Missing)	1526	21.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	116	1.6%
3	130	1.8%
4	129	1.8%
5	114	1.6%
6	114	1.6%
7	116	1.6%
8	120	1.7%
9	116	1.6%
10	132	1.9%
11	145	2.1%

Value	Count	Frequency (%)
85	48	0.7%
82	43	0.6%
76	58	0.8%
75	15	0.2%
73	81	1.2%
71	42	0.6%
69	75	1.1%
59	192	2.7%
58	45	0.6%
57	34	0.5%

Online Security
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	3498
True	2019
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3498	49.7%
True	2019	28.7%
(Missing)	1526	21.7%

Online Backup
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	3088
True	2429
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3088	43.8%
True	2429	34.5%
(Missing)	1526	21.7%

Device Protection Plan
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	3095
True	2422
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3095	43.9%
True	2422	34.4%
(Missing)	1526	21.7%

Premium Tech Support
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	3473
True	2044
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3473	49.3%
True	2044	29.0%
(Missing)	1526	21.7%

Streaming TV
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	2810
True	2707
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2810	39.9%
True	2707	38.4%
(Missing)	1526	21.7%

Streaming Movies
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	2785
True	2732
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2785	39.5%
True	2732	38.8%
(Missing)	1526	21.7%

Streaming Music
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

False	3029
True	2488
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	3029	43.0%
True	2488	35.3%
(Missing)	1526	21.7%

Unlimited Data
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	1526
Missing (%)	21.7%
Memory size	13.9 KiB

True	4745
False	772
(Missing)	1526

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	4745	67.4%
False	772	11.0%
(Missing)	1526	21.7%

Contract
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

Month-to-Month	3610
Two Year	1883
One Year	1550

Length

Max length	14
Median length	14
Mean length	11.07539401
Min length	8

Characters and Unicode

Total characters	78004
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	One Year
2nd row	Month-to-Month
3rd row	Month-to-Month
4th row	Month-to-Month
5th row	Month-to-Month

Common Values

Value	Count	Frequency (%)
Month-to-Month	3610	51.3%
Two Year	1883	26.7%
One Year	1550	22.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
month-to-month	3610	34.5%
year	3433	32.8%
two	1883	18.0%
one	1550	14.8%

Most occurring characters

Value	Count	Frequency (%)
o	12713	16.3%
t	10830	13.9%
n	8770	11.2%
M	7220	9.3%
h	7220	9.3%
-	7220	9.3%
e	4983	6.4%
	3433	4.4%
Y	3433	4.4%
a	3433	4.4%
Other values (4)	8749	11.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	53265	68.3%
Uppercase Letter	14086	18.1%
Dash Punctuation	7220	9.3%
Space Separator	3433	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	12713	23.9%
t	10830	20.3%
n	8770	16.5%
h	7220	13.6%
e	4983	9.4%
a	3433	6.4%
r	3433	6.4%
w	1883	3.5%

Uppercase Letter

Value	Count	Frequency (%)
M	7220	51.3%
Y	3433	24.4%
T	1883	13.4%
O	1550	11.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7220	100.0%

Space Separator

Value	Count	Frequency (%)
	3433	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	67351	86.3%
Common	10653	13.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	12713	18.9%
t	10830	16.1%
n	8770	13.0%
M	7220	10.7%
h	7220	10.7%
e	4983	7.4%
Y	3433	5.1%
a	3433	5.1%
r	3433	5.1%
T	1883	2.8%
Other values (2)	3433	5.1%

Common

Value	Count	Frequency (%)
-	7220	67.8%
	3433	32.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	78004	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	12713	16.3%
t	10830	13.9%
n	8770	11.2%
M	7220	9.3%
h	7220	9.3%
-	7220	9.3%
e	4983	6.4%
	3433	4.4%
Y	3433	4.4%
a	3433	4.4%
Other values (4)	8749	11.2%

Paperless Billing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 KiB

True	4171
False	2872

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	4171	59.2%
False	2872	40.8%

Payment Method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

Bank Withdrawal	3909
Credit Card	2749
Mailed Check	385

Length

Max length	15
Median length	15
Mean length	13.27474088
Min length	11

Characters and Unicode

Total characters	93494
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Credit Card
2nd row	Credit Card
3rd row	Bank Withdrawal
4th row	Bank Withdrawal
5th row	Credit Card

Common Values

Value	Count	Frequency (%)
Bank Withdrawal	3909	55.5%
Credit Card	2749	39.0%
Mailed Check	385	5.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
bank	3909	27.8%
withdrawal	3909	27.8%
credit	2749	19.5%
card	2749	19.5%
mailed	385	2.7%
check	385	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	14861	15.9%
d	9792	10.5%
r	9407	10.1%
	7043	7.5%
i	7043	7.5%
t	6658	7.1%
C	5883	6.3%
h	4294	4.6%
k	4294	4.6%
l	4294	4.6%
Other values (7)	19925	21.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	72365	77.4%
Uppercase Letter	14086	15.1%
Space Separator	7043	7.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	14861	20.5%
d	9792	13.5%
r	9407	13.0%
i	7043	9.7%
t	6658	9.2%
h	4294	5.9%
k	4294	5.9%
l	4294	5.9%
w	3909	5.4%
n	3909	5.4%
Other values (2)	3904	5.4%

Uppercase Letter

Value	Count	Frequency (%)
C	5883	41.8%
B	3909	27.8%
W	3909	27.8%
M	385	2.7%

Space Separator

Value	Count	Frequency (%)
	7043	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	86451	92.5%
Common	7043	7.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	14861	17.2%
d	9792	11.3%
r	9407	10.9%
i	7043	8.1%
t	6658	7.7%
C	5883	6.8%
h	4294	5.0%
k	4294	5.0%
l	4294	5.0%
w	3909	4.5%
Other values (6)	16016	18.5%

Common

Value	Count	Frequency (%)
	7043	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	93494	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	14861	15.9%
d	9792	10.5%
r	9407	10.1%
	7043	7.5%
i	7043	7.5%
t	6658	7.1%
C	5883	6.3%
h	4294	4.6%
k	4294	4.6%
l	4294	4.6%
Other values (7)	19925	21.3%

Monthly Charge
Real number (ℝ)

HIGH CORRELATION

Distinct	1591
Distinct (%)	22.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.59613091

Minimum	-10
Maximum	118.75
Zeros	0
Zeros (%)	0.0%
Negative	120
Negative (%)	1.7%
Memory size	55.1 KiB

Quantile statistics

Minimum	-10
5-th percentile	19.5
Q1	30.4
median	70.05
Q3	89.75
95-th percentile	107.195
Maximum	118.75
Range	128.75
Interquartile range (IQR)	59.35

Descriptive statistics

Standard deviation	31.20474312
Coefficient of variation (CV)	0.4906704648
Kurtosis	-1.125789607
Mean	63.59613091
Median Absolute Deviation (MAD)	24.5
Skewness	-0.2753938343
Sum	447907.55
Variance	973.7359929
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.05	60	0.9%
19.85	45	0.6%
19.95	44	0.6%
19.9	44	0.6%
20	43	0.6%
19.65	42	0.6%
19.7	40	0.6%
20.25	39	0.6%
20.15	39	0.6%
19.55	39	0.6%
Other values (1581)	6608	93.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10	13	0.2%
-9	9	0.1%
-8	12	0.2%
-7	16	0.2%
-6	6	0.1%
-5	11	0.2%
-4	17	0.2%
-3	13	0.2%
-2	10	0.1%
-1	13	0.2%

Value	Count	Frequency (%)
118.75	1	< 0.1%
118.65	1	< 0.1%
118.6	2	< 0.1%
118.35	1	< 0.1%
118.2	1	< 0.1%
117.8	1	< 0.1%
117.6	1	< 0.1%
117.5	1	< 0.1%
117.45	1	< 0.1%
117.35	1	< 0.1%

Total Charges
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6540
Distinct (%)	92.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2280.381264

Minimum	18.8
Maximum	8684.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	18.8
5-th percentile	49.65
Q1	400.15
median	1394.55
Q3	3786.6
95-th percentile	6921.025
Maximum	8684.8
Range	8666
Interquartile range (IQR)	3386.45

Descriptive statistics

Standard deviation	2266.220462
Coefficient of variation (CV)	0.9937901605
Kurtosis	-0.2276926647
Mean	2280.381264
Median Absolute Deviation (MAD)	1219.75
Skewness	0.9637910861
Sum	16060725.24
Variance	5135755.182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
20.2	11	0.2%
19.75	9	0.1%
19.9	8	0.1%
20.05	8	0.1%
19.65	8	0.1%
19.55	7	0.1%
45.3	7	0.1%
20.15	6	0.1%
19.45	6	0.1%
20.25	6	0.1%
Other values (6530)	6967	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.8	1	< 0.1%
18.85	2	< 0.1%
18.9	1	< 0.1%
19	1	< 0.1%
19.05	1	< 0.1%
19.1	3	< 0.1%
19.15	1	< 0.1%
19.2	4	0.1%
19.25	3	< 0.1%
19.3	4	0.1%

Value	Count	Frequency (%)
8684.8	1	< 0.1%
8672.45	1	< 0.1%
8670.1	1	< 0.1%
8594.4	1	< 0.1%
8564.75	1	< 0.1%
8547.15	1	< 0.1%
8543.25	1	< 0.1%
8529.5	1	< 0.1%
8496.7	1	< 0.1%
8477.7	1	< 0.1%

Total Refunds
Real number (ℝ_≥0)

ZEROS

Distinct	500
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.962182309

Minimum	0
Maximum	49.79
Zeros	6518
Zeros (%)	92.5%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	18.149
Maximum	49.79
Range	49.79
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.902614384
Coefficient of variation (CV)	4.027461847
Kurtosis	18.35065824
Mean	1.962182309
Median Absolute Deviation (MAD)	0
Skewness	4.328516701
Sum	13819.65
Variance	62.45131411
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6518	92.5%
16.56	2	< 0.1%
8.74	2	< 0.1%
1.31	2	< 0.1%
41.74	2	< 0.1%
25.67	2	< 0.1%
29.76	2	< 0.1%
18.55	2	< 0.1%
15.41	2	< 0.1%
27.6	2	< 0.1%
Other values (490)	507	7.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6518	92.5%
1.01	1	< 0.1%
1.09	1	< 0.1%
1.27	1	< 0.1%
1.31	2	< 0.1%
1.48	1	< 0.1%
1.65	1	< 0.1%
1.66	1	< 0.1%
1.69	1	< 0.1%
1.83	1	< 0.1%

Value	Count	Frequency (%)
49.79	1	< 0.1%
49.76	1	< 0.1%
49.57	2	< 0.1%
49.53	1	< 0.1%
49.51	1	< 0.1%
49.38	1	< 0.1%
49.37	1	< 0.1%
49.24	1	< 0.1%
49.23	1	< 0.1%
49.22	1	< 0.1%

Total Extra Data Charges
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	16
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.860712764

Minimum	0
Maximum	150
Zeros	6315
Zeros (%)	89.7%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	60
Maximum	150
Range	150
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	25.104978
Coefficient of variation (CV)	3.659237584
Kurtosis	16.45887408
Mean	6.860712764
Median Absolute Deviation (MAD)	0
Skewness	4.091209239
Sum	48320
Variance	630.2599204
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
0	6315	89.7%
10	138	2.0%
40	62	0.9%
30	58	0.8%
20	51	0.7%
80	47	0.7%
100	44	0.6%
50	43	0.6%
150	42	0.6%
130	40	0.6%
Other values (6)	203	2.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6315	89.7%
10	138	2.0%
20	51	0.7%
30	58	0.8%
40	62	0.9%
50	43	0.6%
60	36	0.5%
70	34	0.5%
80	47	0.7%
90	35	0.5%

Value	Count	Frequency (%)
150	42	0.6%
140	38	0.5%
130	40	0.6%
120	28	0.4%
110	32	0.5%
100	44	0.6%
90	35	0.5%
80	47	0.7%
70	34	0.5%
60	36	0.5%

Total Long Distance Charges
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	6068
Distinct (%)	86.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	749.0992617

Minimum	0
Maximum	3564.72
Zeros	682
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	70.545
median	401.44
Q3	1191.1
95-th percentile	2577.877
Maximum	3564.72
Range	3564.72
Interquartile range (IQR)	1120.555

Descriptive statistics

Standard deviation	846.6600548
Coefficient of variation (CV)	1.130237471
Kurtosis	0.644092077
Mean	749.0992617
Median Absolute Deviation (MAD)	382.12
Skewness	1.238281984
Sum	5275906.1
Variance	716833.2484
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	682	9.7%
15.6	4	0.1%
48.96	4	0.1%
22.86	4	0.1%
597.6	3	< 0.1%
2077.92	3	< 0.1%
198	3	< 0.1%
15.28	3	< 0.1%
808.08	3	< 0.1%
41.1	3	< 0.1%
Other values (6058)	6331	89.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	682	9.7%
1.13	1	< 0.1%
1.15	1	< 0.1%
1.17	1	< 0.1%
1.23	1	< 0.1%
1.28	1	< 0.1%
1.47	1	< 0.1%
1.48	1	< 0.1%
1.5	1	< 0.1%
1.59	1	< 0.1%

Value	Count	Frequency (%)
3564.72	1	< 0.1%
3564	1	< 0.1%
3536.64	1	< 0.1%
3515.92	1	< 0.1%
3508.82	1	< 0.1%
3501.72	1	< 0.1%
3493.44	1	< 0.1%
3492.72	1	< 0.1%
3487.68	1	< 0.1%
3482.64	1	< 0.1%

Total Revenue
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	6975
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3034.379056

Minimum	21.36
Maximum	11979.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	55.1 KiB

Quantile statistics

Minimum	21.36
5-th percentile	78.452
Q1	605.61
median	2108.64
Q3	4801.145
95-th percentile	8747.041
Maximum	11979.34
Range	11957.98
Interquartile range (IQR)	4195.535

Descriptive statistics

Standard deviation	2865.204542
Coefficient of variation (CV)	0.9442474025
Kurtosis	-0.2034573897
Mean	3034.379056
Median Absolute Deviation (MAD)	1767.61
Skewness	0.919410268
Sum	21371131.69
Variance	8209397.065
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24.8	3	< 0.1%
116.27	3	< 0.1%
68.41	3	< 0.1%
66.56	3	< 0.1%
3386.4	2	< 0.1%
174.93	2	< 0.1%
608.85	2	< 0.1%
712.85	2	< 0.1%
3423.5	2	< 0.1%
88.75	2	< 0.1%
Other values (6965)	7019	99.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
21.36	1	< 0.1%
21.4	1	< 0.1%
21.61	1	< 0.1%
22.08	1	< 0.1%
22.12	1	< 0.1%
22.25	1	< 0.1%
22.28	1	< 0.1%
22.54	1	< 0.1%
23.24	2	< 0.1%
23.28	1	< 0.1%

Value	Count	Frequency (%)
11979.34	1	< 0.1%
11868.34	1	< 0.1%
11795.78	1	< 0.1%
11688.9	1	< 0.1%
11634.53	1	< 0.1%
11596.99	1	< 0.1%
11564.37	1	< 0.1%
11529.54	1	< 0.1%
11514.81	1	< 0.1%
11501.82	1	< 0.1%

Customer Status
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	55.1 KiB

Stayed	4720
Churned	1869
Joined	454

Length

Max length	7
Median length	6
Mean length	6.265369871
Min length	6

Characters and Unicode

Total characters	44127
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Stayed
2nd row	Stayed
3rd row	Churned
4th row	Churned
5th row	Churned

Common Values

Value	Count	Frequency (%)
Stayed	4720	67.0%
Churned	1869	26.5%
Joined	454	6.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
stayed	4720	67.0%
churned	1869	26.5%
joined	454	6.4%

Most occurring characters

Value	Count	Frequency (%)
e	7043	16.0%
d	7043	16.0%
S	4720	10.7%
t	4720	10.7%
a	4720	10.7%
y	4720	10.7%
n	2323	5.3%
C	1869	4.2%
h	1869	4.2%
u	1869	4.2%
Other values (4)	3231	7.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37084	84.0%
Uppercase Letter	7043	16.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	7043	19.0%
d	7043	19.0%
t	4720	12.7%
a	4720	12.7%
y	4720	12.7%
n	2323	6.3%
h	1869	5.0%
u	1869	5.0%
r	1869	5.0%
o	454	1.2%

Uppercase Letter

Value	Count	Frequency (%)
S	4720	67.0%
C	1869	26.5%
J	454	6.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44127	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	7043	16.0%
d	7043	16.0%
S	4720	10.7%
t	4720	10.7%
a	4720	10.7%
y	4720	10.7%
n	2323	5.3%
C	1869	4.2%
h	1869	4.2%
u	1869	4.2%
Other values (4)	3231	7.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	44127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	7043	16.0%
d	7043	16.0%
S	4720	10.7%
t	4720	10.7%
a	4720	10.7%
y	4720	10.7%
n	2323	5.3%
C	1869	4.2%
h	1869	4.2%
u	1869	4.2%
Other values (4)	3231	7.3%

Churn Category
Categorical

HIGH CORRELATION
MISSING

Distinct	5
Distinct (%)	0.3%
Missing	5174
Missing (%)	73.5%
Memory size	55.1 KiB

Competitor	841
Dissatisfaction	321
Attitude	314
Price	211
Other	182

Length

Max length	15
Median length	10
Mean length	9.471375067
Min length	5

Characters and Unicode

Total characters	17702
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Competitor
2nd row	Dissatisfaction
3rd row	Dissatisfaction
4th row	Dissatisfaction
5th row	Competitor

Common Values

Value	Count	Frequency (%)
Competitor	841	11.9%
Dissatisfaction	321	4.6%
Attitude	314	4.5%
Price	211	3.0%
Other	182	2.6%
(Missing)	5174	73.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
competitor	841	45.0%
dissatisfaction	321	17.2%
attitude	314	16.8%
price	211	11.3%
other	182	9.7%

Most occurring characters

Value	Count	Frequency (%)
t	3448	19.5%
i	2329	13.2%
o	2003	11.3%
e	1548	8.7%
r	1234	7.0%
s	963	5.4%
C	841	4.8%
m	841	4.8%
p	841	4.8%
a	642	3.6%
Other values (10)	3012	17.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15833	89.4%
Uppercase Letter	1869	10.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	3448	21.8%
i	2329	14.7%
o	2003	12.7%
e	1548	9.8%
r	1234	7.8%
s	963	6.1%
m	841	5.3%
p	841	5.3%
a	642	4.1%
c	532	3.4%
Other values (5)	1452	9.2%

Uppercase Letter

Value	Count	Frequency (%)
C	841	45.0%
D	321	17.2%
A	314	16.8%
P	211	11.3%
O	182	9.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17702	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	3448	19.5%
i	2329	13.2%
o	2003	11.3%
e	1548	8.7%
r	1234	7.0%
s	963	5.4%
C	841	4.8%
m	841	4.8%
p	841	4.8%
a	642	3.6%
Other values (10)	3012	17.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17702	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	3448	19.5%
i	2329	13.2%
o	2003	11.3%
e	1548	8.7%
r	1234	7.0%
s	963	5.4%
C	841	4.8%
m	841	4.8%
p	841	4.8%
a	642	3.6%
Other values (10)	3012	17.0%

Churn Reason
Categorical

HIGH CORRELATION
MISSING

Distinct	20
Distinct (%)	1.1%
Missing	5174
Missing (%)	73.5%
Memory size	55.1 KiB

Competitor had better devices	313
Competitor made better offer	311
Attitude of support person	220
Don't know	130
Competitor offered more data	117
Other values (15)	778

Length

Max length	41
Median length	32
Mean length	25.25682183
Min length	5

Characters and Unicode

Total characters	47205
Distinct characters	37
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Competitor had better devices
2nd row	Product dissatisfaction
3rd row	Network reliability
4th row	Limited range of services
5th row	Competitor made better offer

Common Values

Value	Count	Frequency (%)
Competitor had better devices	313	4.4%
Competitor made better offer	311	4.4%
Attitude of support person	220	3.1%
Don't know	130	1.8%
Competitor offered more data	117	1.7%
Competitor offered higher download speeds	100	1.4%
Attitude of service provider	94	1.3%
Price too high	78	1.1%
Product dissatisfaction	77	1.1%
Network reliability	72	1.0%
Other values (10)	357	5.1%
(Missing)	5174	73.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
competitor	841	12.6%
better	624	9.4%
of	453	6.8%
attitude	314	4.7%
had	313	4.7%
devices	313	4.7%
made	311	4.7%
offer	311	4.7%
support	263	4.0%
person	220	3.3%
Other values (37)	2694	40.5%

Most occurring characters

Value	Count	Frequency (%)
e	6138	13.0%
t	5212	11.0%
	4788	10.1%
o	4650	9.9%
r	3698	7.8%
i	2918	6.2%
d	2538	5.4%
s	1917	4.1%
p	1896	4.0%
a	1816	3.8%
Other values (27)	11634	24.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	40330	85.4%
Space Separator	4788	10.1%
Uppercase Letter	1898	4.0%
Other Punctuation	160	0.3%
Dash Punctuation	29	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	6138	15.2%
t	5212	12.9%
o	4650	11.5%
r	3698	9.2%
i	2918	7.2%
d	2538	6.3%
s	1917	4.8%
p	1896	4.7%
a	1816	4.5%
f	1738	4.3%
Other values (13)	7809	19.4%

Uppercase Letter

Value	Count	Frequency (%)
C	841	44.3%
A	314	16.5%
P	198	10.4%
L	160	8.4%
D	136	7.2%
N	72	3.8%
S	63	3.3%
M	46	2.4%
E	39	2.1%
W	29	1.5%

Other Punctuation

Value	Count	Frequency (%)
'	130	81.2%
/	30	18.8%

Space Separator

Value	Count	Frequency (%)
	4788	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	29	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	42228	89.5%
Common	4977	10.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	6138	14.5%
t	5212	12.3%
o	4650	11.0%
r	3698	8.8%
i	2918	6.9%
d	2538	6.0%
s	1917	4.5%
p	1896	4.5%
a	1816	4.3%
f	1738	4.1%
Other values (23)	9707	23.0%

Common

Value	Count	Frequency (%)
	4788	96.2%
'	130	2.6%
/	30	0.6%
-	29	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47205	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	6138	13.0%
t	5212	11.0%
	4788	10.1%
o	4650	9.9%
r	3698	7.8%
i	2918	6.2%
d	2538	5.4%
s	1917	4.1%
p	1896	4.0%
a	1816	3.8%
Other values (27)	11634	24.6%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	Customer ID	Gender	Age	Married	Number of Dependents	City	Zip Code	Latitude	Longitude	Number of Referrals	Tenure in Months	Offer	Phone Service	Avg Monthly Long Distance Charges	Multiple Lines	Internet Service	Internet Type	Avg Monthly GB Download	Online Security	Online Backup	Device Protection Plan	Premium Tech Support	Streaming TV	Streaming Movies	Streaming Music	Unlimited Data	Contract	Paperless Billing	Payment Method	Monthly Charge	Total Charges	Total Refunds	Total Extra Data Charges	Total Long Distance Charges	Total Revenue	Customer Status	Churn Category	Churn Reason
0	0002-ORFBO	Female	37	Yes	0	Frazier Park	93225	34.827662	-118.999073	2	9	None	Yes	42.39	No	Yes	Cable	16.0	No	Yes	No	Yes	Yes	No	No	Yes	One Year	Yes	Credit Card	65.60	593.30	0.00	0	381.51	974.81	Stayed	NaN	NaN
1	0003-MKNFE	Male	46	No	0	Glendale	91206	34.162515	-118.203869	0	9	None	Yes	10.69	Yes	Yes	Cable	10.0	No	No	No	No	No	Yes	Yes	No	Month-to-Month	No	Credit Card	-4.00	542.40	38.33	10	96.21	610.28	Stayed	NaN	NaN
2	0004-TLHLJ	Male	50	No	0	Costa Mesa	92627	33.645672	-117.922613	0	4	Offer E	Yes	33.65	No	Yes	Fiber Optic	30.0	No	No	Yes	No	No	No	No	Yes	Month-to-Month	Yes	Bank Withdrawal	73.90	280.85	0.00	0	134.60	415.45	Churned	Competitor	Competitor had better devices
3	0011-IGKFF	Male	78	Yes	0	Martinez	94553	38.014457	-122.115432	1	13	Offer D	Yes	27.82	No	Yes	Fiber Optic	4.0	No	Yes	Yes	No	Yes	Yes	No	Yes	Month-to-Month	Yes	Bank Withdrawal	98.00	1237.85	0.00	0	361.66	1599.51	Churned	Dissatisfaction	Product dissatisfaction
4	0013-EXCHZ	Female	75	Yes	0	Camarillo	93010	34.227846	-119.079903	3	3	None	Yes	7.38	No	Yes	Fiber Optic	11.0	No	No	No	Yes	Yes	No	No	Yes	Month-to-Month	Yes	Credit Card	83.90	267.40	0.00	0	22.14	289.54	Churned	Dissatisfaction	Network reliability
5	0013-MHZWF	Female	23	No	3	Midpines	95345	37.581496	-119.972762	0	9	Offer E	Yes	16.77	No	Yes	Cable	73.0	No	No	No	Yes	Yes	Yes	Yes	Yes	Month-to-Month	Yes	Credit Card	69.40	571.45	0.00	0	150.93	722.38	Stayed	NaN	NaN
6	0013-SMEOE	Female	67	Yes	0	Lompoc	93437	34.757477	-120.550507	1	71	Offer A	Yes	9.96	No	Yes	Fiber Optic	14.0	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Two Year	Yes	Bank Withdrawal	109.70	7904.25	0.00	0	707.16	8611.41	Stayed	NaN	NaN
7	0014-BMAQU	Male	52	Yes	0	Napa	94558	38.489789	-122.270110	8	63	Offer B	Yes	12.96	Yes	Yes	Fiber Optic	7.0	Yes	No	No	Yes	No	No	No	No	Two Year	Yes	Credit Card	84.65	5377.80	0.00	20	816.48	6214.28	Stayed	NaN	NaN
8	0015-UOCOJ	Female	68	No	0	Simi Valley	93063	34.296813	-118.685703	0	7	Offer E	Yes	10.53	No	Yes	DSL	21.0	Yes	No	No	No	No	No	No	Yes	Two Year	Yes	Bank Withdrawal	48.20	340.35	0.00	0	73.71	414.06	Stayed	NaN	NaN
9	0016-QLJIS	Female	43	Yes	1	Sheridan	95681	38.984756	-121.345074	3	65	None	Yes	28.46	Yes	Yes	Cable	14.0	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Two Year	Yes	Credit Card	90.45	5957.90	0.00	0	1849.90	7807.80	Stayed	NaN	NaN

Last rows

	Customer ID	Gender	Age	Married	Number of Dependents	City	Zip Code	Latitude	Longitude	Number of Referrals	Tenure in Months	Offer	Phone Service	Avg Monthly Long Distance Charges	Multiple Lines	Internet Service	Internet Type	Avg Monthly GB Download	Online Security	Online Backup	Device Protection Plan	Premium Tech Support	Streaming TV	Streaming Movies	Streaming Music	Unlimited Data	Contract	Paperless Billing	Payment Method	Monthly Charge	Total Charges	Total Extra Data Charges	Total Long Distance Charges	Total Revenue	Customer Status	Churn Category	Churn Reason
7033	9975-SKRNR	Male	24	No	0	Sierraville	96126	39.559709	-120.345639	0	1	Offer E	Yes	49.51	No	No	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Month-to-Month	No	Credit Card	18.90	18.90	0	49.51	68.41	Joined	NaN	NaN
7034	9978-HYCIN	Male	72	Yes	1	Bakersfield	93301	35.383937	-119.020428	1	47	None	Yes	42.29	No	Yes	Fiber Optic	22.0	No	Yes	No	No	Yes	No	No	No	One Year	Yes	Bank Withdrawal	84.95	4018.05	80	1987.63	6085.68	Stayed	NaN	NaN
7035	9979-RGMZT	Female	20	No	0	Los Angeles	90022	34.023810	-118.156582	0	7	Offer E	Yes	36.49	No	Yes	Fiber Optic	42.0	No	Yes	No	No	Yes	Yes	Yes	Yes	One Year	Yes	Credit Card	94.05	633.45	0	255.43	888.88	Stayed	NaN	NaN
7036	9985-MWVIX	Female	53	No	0	Hume	93628	36.807595	-118.901544	0	1	Offer E	Yes	42.09	No	Yes	Fiber Optic	9.0	No	No	No	No	No	No	No	Yes	Month-to-Month	Yes	Credit Card	70.15	70.15	0	42.09	112.24	Churned	Competitor	Competitor had better devices
7037	9986-BONCE	Female	36	No	0	Fallbrook	92028	33.362575	-117.299644	0	4	None	Yes	2.01	No	No	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	Month-to-Month	No	Bank Withdrawal	20.95	85.50	0	8.04	93.54	Churned	Competitor	Competitor made better offer
7038	9987-LUTYD	Female	20	No	0	La Mesa	91941	32.759327	-116.997260	0	13	Offer D	Yes	46.68	No	Yes	DSL	59.0	Yes	No	No	Yes	No	No	Yes	Yes	One Year	No	Credit Card	55.15	742.90	0	606.84	1349.74	Stayed	NaN	NaN
7039	9992-RRAMN	Male	40	Yes	0	Riverbank	95367	37.734971	-120.954271	1	22	Offer D	Yes	16.20	Yes	Yes	Fiber Optic	17.0	No	No	No	No	No	Yes	Yes	Yes	Month-to-Month	Yes	Bank Withdrawal	85.10	1873.70	0	356.40	2230.10	Churned	Dissatisfaction	Product dissatisfaction
7040	9992-UJOEL	Male	22	No	0	Elk	95432	39.108252	-123.645121	0	2	Offer E	Yes	18.62	No	Yes	DSL	51.0	No	Yes	No	No	No	No	No	Yes	Month-to-Month	Yes	Credit Card	50.30	92.75	0	37.24	129.99	Joined	NaN	NaN
7041	9993-LHIEB	Male	21	Yes	0	Solana Beach	92075	33.001813	-117.263628	5	67	Offer A	Yes	2.12	No	Yes	Cable	58.0	Yes	No	Yes	Yes	No	Yes	Yes	Yes	Two Year	No	Credit Card	67.85	4627.65	0	142.04	4769.69	Stayed	NaN	NaN
7042	9995-HOTOH	Male	36	Yes	0	Sierra City	96125	39.600599	-120.636358	1	63	None	No	NaN	NaN	Yes	Cable	5.0	Yes	Yes	Yes	No	Yes	Yes	Yes	Yes	Two Year	No	Bank Withdrawal	59.00	3707.60	0	0.00	3707.60	Stayed	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length